/*
verify PF with excel - mark with green




select Y,M,count(1) as [count]
from
(
	select datepart(YEAR,expenseDate) as Y, datepart(MONTH,expenseDate) as M, datepart(DAY,expenseDate) as D
	from tblExpensesP1
	group by datepart(YEAR,expenseDate), datepart(MONTH,expenseDate), datepart(DAY,expenseDate)
	--order by 1 desc,2 desc,3 desc
) [all]
group by Y,M
order by Y desc,M desc










iCalms > LINQ
Tech Assist
Knome msg



f-GAP: Finance Guide, Advisor & Planner - One step ahead towards betterment

*/

CREATE SCHEMA FGAP
GO

CREATE 
